Release 10.1A: OpenEdge Development:
Progress 4GL Reference

USERID function

Returns the user ID of the current user.

Syntax

USERID [ ( logical-dbname ) ]

logical-dbname

The logical name of the database from which you want to retrieve the user ID. The logical database name must be a character string enclosed in quotes, or a character expression. If you do not specify this argument, the Compiler inserts the name of the database that is connected when the procedure is compiled. If you omit this argument and more than one database is connected, Progress returns a compiler error.

Example

This one-line procedure displays the current user ID for the database with the DICTDB alias:

r-userid.p

DISPLAY USERID("DICTDB") LABEL "You are logged in as" WITH SIDE-LABELS.

Notes

Use the Userid (-U) parameter together with the Password (-P) parameter. Progress checks the _User table for the user ID supplied with the -U parameter. When it finds that user ID, it compares the password supplied with the -P parameter with the password in the _User table. If the two passwords match, Progress assigns that user ID to the OpenEdge session.
When using the USERID function, Progress returns a compiler error under the following conditions:
There is no database connected.
You omit the logical-dbname argument and more than one database is currently connected.
When specifying the logical-dbname argument, you must provide the name of the logical database, not the physical database.
Every user who enters Progress is given an initial user ID.

Table 51 shows how Progress determines a user’s initial user ID on UNIX.

Table 51: Determining a UNIX user ID 

Are there records in the _User table?	Are the -U and -P startup options supplied?	User ID
NO	YES	Error: -U and -P not allowed unless there are entries in the _User table.
NO	NO	UNIX user ID.
YES	NO	"" (blank user ID).
YES	YES	If the -U userid and -P password match those in the _User table, use that user ID. Otherwise, do not assign a user ID.

Table 52 shows how Progress determines a user’s initial user ID in Windows.

Table 52: Determining a Windows user ID 

Are there records in the _User table?	Are the -U and -P startup options supplied?	User ID
NO	YES	Error: -U and -P not allowed unless there are entries in the _User table.
NO	NO	"" (blank user ID) or operating system user ID if available.
YES	NO	"" (blank user ID.
YES	YES	If the -U userid and -P password match those in the _User table, use that user ID. Otherwise, do not assign a user ID.

After Progress starts running, you can use the SETUSERID function to change the current user ID.
Progress user IDs are case sensitive.
See OpenEdge Development: Programming Interfaces and OpenEdge Data Management: Database Administration for more information on security.

See also

CONNECT statement, SETUSERID function